Release 10.1A: OpenEdge Data Management:
SQL Reference

DAYNAME

Returns a character string containing the name of the day (for example, Sunday through Saturday) for the day portion of date_expression. The argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.

Syntax

DAYNAME ( date_expression )

Example

This example illustrates the DAYNAME function:

SELECT * FROM orders WHERE order_no = 342 and DAYNAME(order_date)= 'SATURDAY'; ORDER_NO ORDER_DATE REFERENCE CUST_NO -------- ----------- ---------- -------- 342 08/10 tdfg/101 10001 1 record selected

Compatibility

ODBC compatible